package com.Lgwd.repository;

import com.Lgwd.entity.DropGoodsEntity;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository
public interface DropGoodsRepository extends JpaRepository<DropGoodsEntity,Integer> {



    @Query(value="select * FROM `dropgoods` where lv_scope=?1" , nativeQuery = true)
    List<DropGoodsEntity> findByLv_scope(@Param("lv_scope")int lvscope);
}
